Tabela PhAuctionOffer

Definicja tabeli PhAuctionOffer

Name

PhAuctionOffer

Code

PhAuctionOffer

Comment

Oferta przetargowa


Lista kolumn tabeli PhAuctionOffer

Name

Code

AuctionOfferID

AuctionOfferID

DelivererID

DelivererID

offerDt

offerDt

Info

Info

OfferNo

OfferNo

Active

Active

StatusID

StatusID

AuctionID

AuctionID


Kolumna AuctionOfferID tabeli PhAuctionOffer

Definicja kolumny AuctionOfferID tabeli PhAuctionOffer

Name

AuctionOfferID

Code

AuctionOfferID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Klucz


Kolumna DelivererID tabeli PhAuctionOffer

Definicja kolumny DelivererID tabeli PhAuctionOffer

Name

DelivererID

Code

DelivererID

Data Type

NUMBER(10)

Mandatory

No

Comment

Dostawca fk do tabeli PhCompany


Kolumna offerDt tabeli PhAuctionOffer

Definicja kolumny offerDt tabeli PhAuctionOffer

Name

offerDt

Code

offerDt

Data Type

DATE

Mandatory

No

Comment

Data przedstawienia oferty


Kolumna Info tabeli PhAuctionOffer

Definicja kolumny Info tabeli PhAuctionOffer

Name

Info

Code

Info

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Komentarz do oferty


Kolumna OfferNo tabeli PhAuctionOffer

Definicja kolumny OfferNo tabeli PhAuctionOffer

Name

OfferNo

Code

OfferNo

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Numer oferty


Kolumna Active tabeli PhAuctionOffer

Definicja kolumny Active tabeli PhAuctionOffer

Name

Active

Code

Active

Data Type

NUMBER(3)

Mandatory

Yes

Comment

Czy aktywna


Kolumna StatusID tabeli PhAuctionOffer

Definicja kolumny StatusID tabeli PhAuctionOffer

Name

StatusID

Code

StatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

Status oferty fk do tabeli PhAuctionOfferStatus


Kolumna AuctionID tabeli PhAuctionOffer

Definicja kolumny AuctionID tabeli PhAuctionOffer

Name

AuctionID

Code

AuctionID

Data Type

NUMBER(10)

Mandatory

No

Comment

Przetarg do którego skladana jest oferta fk do
PhAuction


Lista kluczy tabeli PhAuctionOffer

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PhAuctionOffer

Definicja klucza Identifier_1 tabeli PhAuctionOffer

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment